The Smart Reorder Page
Open Smart Reorder in the main menu.
Summary cards
| Card | What it shows |
|---|---|
| Need to order | Products that will run out before a new order could arrive. Order these first. |
| Recommended | Products at or below their reorder point. Order them now to avoid running out. |
| Healthy | Products with enough stock for now. |
| Overstock | Products with more stock than your overstock threshold (120 days of sales by default). |
| Revenue at risk | Total sales you could lose because products run out before a new order arrives, if you ordered everything today. |
| Recommended purchase | Total cost of all recommended quantities (Need to order + Recommended), per currency. Products without a cost aren't counted. |
Click a status card to show only the products in that status.
Under the cards, Last calculated shows how long ago the recommendations were updated. Click Recalculate to update them now.
Statuses
| Status | When |
|---|---|
| Need to order | Stock plus incoming will run out within the supplier's lead time. Even if you order today, you may run out before the goods arrive. |
| Recommended | Stock plus incoming is at or below the reorder point (the stock needed to cover the lead time plus safety stock, or your min stock if higher). Also used for a product with no recent sales whose stock is below its min stock. |
| Healthy | Enough stock for now. No order needed yet. |
| Overstock | More stock than your overstock threshold, in days of sales. Consider not reordering. |
| No sales | No sales in the last 90 days, and no min stock to keep up. |
The exact rules are in How recommendations are calculated.
Filters and search
- Status: tick one or more statuses. Need to order and Recommended are ticked by default.
- Supplier: show one supplier's products, or No supplier for products not assigned to any supplier.
- Vendor: show one vendor's products.
- Search: product name, variant name or SKU.
The list is sorted by Revenue at risk (highest first) by default, so the products that cost you the most when they run out come first. Click a column header to sort by another column.
Columns
| Column | Meaning |
|---|---|
| Product | Product, variant and SKU |
| Status | See above |
| On hand | Current stock in Shopify, all locations |
| Incoming | Quantity still to be received on open purchase orders (Pending, Confirmed, Transferring) |
| Avg/day | Average daily sales, not counting days the product was out of stock |
| Days of stock | How many days the stock on hand lasts at the current sales speed ("—" when there are no sales) |
| Lead time | Days the supplier takes to deliver |
| Recommended qty | Quantity to order. You can change it before creating a PO. |
| Supplier | Supplier picked for this product, or No supplier |
| Unit cost | Supplier price, or Shopify cost in the same currency ("—" when there is none) |
| Est. cost | Recommended qty × unit cost |
| Revenue at risk | Sales you could lose before a new order arrives |
| Why? | Opens the explanation for this product. See Why? explanations. |
Export to CSV
Click Export Csv to download every product matching the current filters (not only the page you're on). On top of the columns above, the file includes the vendor, sales for 30/60/90 days, days out of stock (last 30 days), where the lead time comes from, the order cycle, the reorder point, the target stock, why the supplier was picked, the currency and the expected stock-out date. It's handy for checking the numbers in a spreadsheet or sharing them with your team.
Recalculate
Recommendations are updated automatically at least every 6 hours. Click Recalculate after you change settings, receive a delivery or create purchase orders, to see updated numbers right away.
- Most shops are done in a few seconds and the page reloads by itself.
- For a large catalog, the page shows Calculating… x / y products and keeps showing the previous results until the new ones are ready. You can leave the page; the calculation keeps running in the background.